What is Amazon Athena's best feature?

Reviewers rate Monitoring and metrics highest, with a score of 8.7.

Who uses Amazon Athena?

The most common users of Amazon Athena are from Mid-sized Companies (51-1,000 employees).

Amazon Athena Reviews & Ratings 2024

Starting at $5 per TB of Data Scanned

Overview

What is Amazon Athena?

Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. With a few clicks in the AWS Management Console, customers can point Athena at their data stored in S3…

Recent Reviews

Amazon Athena - Faster and interactive query processing engine on Amazon S3

10 out of 10

September 05, 2022

Incentivized

In my current organization, we use Amazon Athena for querying data from AWS S3 location. It provides faster access to data as compared to …

Didn't knew I could do a lot more with this

10 out of 10

August 30, 2022

Incentivized

We extensively use AWS Load balancers and a lot of traffic needs retrospection. Athena makes it quite simple and useful to query our …

Great value for the money

8 out of 10

July 25, 2022

Incentivized

We use Amazon Athena to overlay a bunch of direct-to-consumer click stream data. The most common queries are looking at attribution …

Read all reviews

Return to navigation

Pricing

View all pricing

Price per Query

$5.00

Cloud

per TB of Data Scanned

Entry-level set up fee?

No setup fee

Offerings

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services

Return to navigation

Product Details

About
Tech Details

What is Amazon Athena?

Amazon Athena Technical Details

Deployment Types	Software as a Service (SaaS), Cloud, or Web-Based
Operating Systems	Unspecified
Mobile Application	No

Return to navigation

Comparisons

View all alternatives

Compare with

Reviews and Ratings

(38)

Reviews

(1-2 of 2)

Sort By *

Companies can't remove reviews or game the system. Here's why

September 05, 2022

Amazon Athena - Faster and interactive query processing engine on Amazon S3

Riyaz Khan

Data Engineer

Reliance Jio Platforms Ltd. (Information Technology & Services, 10,001+ employees)

Score 10 out of 10

Vetted Review

Verified User

Incentivized

Use Cases and Deployment Scope

In my current organization, we use Amazon Athena for querying data from AWS S3 location. It provides faster access to data as compared to the traditional relational database management system. Also, it helps to work with complex data structures such as JSON, Parquet, CSV, and Avro. Earlier we were using some traditional RDBMS for reporting Ecommerce related KPIs which has lots of transactional data coming in. Performance was not much good for querying huge amount of real-time inventory data. So, we moved to Amazon Athena to support fast interactive querying of data and processing.

Pros and Cons

Nested Schemas like JSON data structure
Ability to adapt the data model to fit your queries better
Performance Improvement

Complex query optimization
Limited performance on AWS S3
Partioning and columnar format to maximize MPP

Likelihood to Recommend

Best suited for analyzing huge amounts of data by just querying on Amazon Athena. Amazon Athena is also best to integrate with Amazon Quickight for visualization and reporting of data. Easy to work with CSV, JSON, and columnar data formats like Parquet, and ORC. Less appropriate to work with AVRO data format and also stored procedures are not supported in Amazon Athena. The size of a single row is also limited to 32 MB.

Amazon Athena Feature Ratings

Database-as-a-Service (6)

96.66666666666666%

9.7

Automatic software patching: 90%
9.0
Database scalability: 90%
9.0
Automated backups: 100%
10.0
Database security provisions: 100%
10.0
Monitoring and metrics: 100%
10.0
Automatic host deployment: 100%
10.0

Return on Investment

Easy to query terabytes of data with faster response
Pricing model is also cheap
No indexing and partitioning

Alternatives Considered

Amazon Redshift and Amazon EMR (Elastic MapReduce)

Amazon Redshift and EMR require explicit configuration for underlying compute infrastructure. In Amazon Athena, Users don't have to set up any underlying infrastructure. It saves a lot of costs required for infrastructure. Users have to pay only for scanned data. Athena is good for ad-hoc query analysis without setting up any infrastructure.

Other Software Used

Amazon EMR (Elastic MapReduce), Amazon QuickSight, Amazon Aurora

August 30, 2022

Didn't knew I could do a lot more with this

Verified User

Team Lead in Engineering

Telecommunications Company, 201-500 employees

Score 10 out of 10

Vetted Review

Verified User

Incentivized

Use Cases and Deployment Scope

We extensively use AWS Load balancers and a lot of traffic needs retrospection. Athena makes it quite simple and useful to query our traffic and analyze the service architecture. We also use AWS S3 extensively. Athena makes it quite simple to query around half a million records daily. We have tried other open source tools, none of which has been able to work in as fewer efforts as Athena did. I would definitely recommend it to others.

Pros and Cons

Load Balance traffic analysis
Big data report generation
Micro services pattern query analysis

Query manager can incoperate GUI based query designer
Auto-completion engine sometimes overwrite the query
Time range selection should be implicit

Likelihood to Recommend

We use Athena extensively on our load balance traffic analyser. It helps us filter out bad requests and reason them quickly. Hence, a useful toolkit for monitoring stack We also use Athena on our report generation on a million per day datasets. It helps report generation quickly and easily on daily basis, which would've taken a lot of engineering efforts.